SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401870 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401870 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550067,128716,161092,932553,549336,367650,538729,880481,82125,157789,496221,712696,385079,790549,444006,630206,694952,909555,338014,453752,250518,885159,152163,713624,481252,302289,853893,298764,676425,99611,771901,615634,141305,125236,382794,363730,43401,297995,654427,82573,215035,985904,49488,910414,799382,431345,838459,476064,690170,803500,521798,1014814,895438,456948,281468,23579,739127,266518,885798,1031048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]