SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496315 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496315 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10500,625564,857713,737042,578088,757602,310144,846462,569958,180551,289396,779711,662764,465849,35089,725607,627868,938007,815901,202609,171166,442973,125701,307721,420328,545671,952356,592833,211170,221565,666770,270007,733201,296706,689413,554988,191537,251565,355748,690145,87642,570932,523160,937401,499159,537310,556703,411196,319966,993794,813580,481687,29714,58880,822610,67509,719739,980574,31076,156636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]