SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522017 LIMIT 1 [ RunTime:0.004421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522017 [ RunTime:0.002778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229583,665488,148774,236553,35944,620279,510733,982532,478155,621265,845463,476210,927046,701209,93739,611293,294757,843977,464957,195464,133780,272180,577878,3581,8658,827363,318711,386205,823768,1015698,43167,800043,334731,440527,685167,502104,20294,720169,641686,21571,17731,368949,688685,785837,454763,416388,1032060,763178,387202,429970,682104,407725,229807,530280,354624,610026,762668,834357,522911) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]