SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432200 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432200 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429660,724323,181004,464037,460339,569934,540604,498896,295966,327346,57854,318987,830337,27811,854167,849645,704656,1016763,786173,119156,1022576,736667,59872,548287,894174,159539,183116,39311,496893,893915,906964,377830,525897,872598,253117,590310,124085,324658,525344,107308,361855,976226,246768,149072,652577,350264,257340,1007111,935000,188046,397028,816950,806141,677400,566531,68611,451081,798445,491719,689694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]