SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514457 LIMIT 1 [ RunTime:0.001138s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514457 [ RunTime:0.002422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109020,425226,600500,671276,586816,1015059,553484,650892,618070,33578,101090,85014,678183,332642,764523,758266,96077,994312,131078,414348,339442,255664,893319,581972,600952,192995,812820,860208,369493,301201,400698,860258,378831,814990,454695,821163,715009,450615,672827,996128,470955,450592,678203,347139,1027031,720626,664202,4704,1039672,830154,637847,532570,856773,791237,547930,299645,664255,652893,381322,847023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000867s ]