SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445542 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445542 [ RunTime:0.005790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396873,903606,328919,898596,517185,492187,913235,973414,644182,622148,671644,440638,468315,66437,721490,69697,275851,717984,618011,693783,674639,921489,875419,125375,485779,1016743,358361,352169,1042959,417316,656809,873738,965892,279883,383951,144241,115449,90313,71500,449551,952441,630917,604234,252752,308109,517338,194578,424076,878597,1045948,763087,281561,950191,155404,492899,902911,769985,900895,860899,344980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]