SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3118 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3118 [ RunTime:0.005027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235605,635959,692666,97834,883389,259132,671948,873775,63816,186213,217977,554112,890721,867906,451813,359448,671949,783352,378910,400057,861659,981955,267575,456496,975099,689646,214364,19694,328791,1006689,608796,212140,28787,824330,92453,308264,458288,367629,18595,875666,955924,1005485,494111,973430,894176,162426,574644,670655,259723,375805,1026604,1047313,249047,654362,881280,443622,255553,64527,197494,383124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]