SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002891 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002891 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704607,986637,91991,543102,366319,794416,241366,227087,337786,283746,100925,955968,956896,624885,246577,436324,130078,741729,475698,91979,886646,375021,568362,763912,669669,658565,574321,975435,72708,771994,832023,691522,689194,155171,217604,212437,735282,611510,305011,1007742,424069,510321,1025395,460760,533081,314342,825165,578140,893404,523744,564965,520732,647182,372845,908292,904529,426908,314009,554910,920278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]