SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260418 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260418 [ RunTime:0.002105s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615223,171713,96168,1016921,667618,698879,319423,214535,827020,73484,858199,225993,410184,439047,158320,822422,902768,315202,708934,394702,497125,773452,440408,1017353,329795,288854,969963,188421,111341,276913,444902,612922,619402,970948,490980,597554,455015,807439,927128,196021,545842,36057,249171,116431,846245,375366,580107,1030651,137493,694400,519416,766439,1044992,546646,961096,269228,157902,256025,215931,1002021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002040s ]