SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490463 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490463 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516141,837380,999110,1042146,716226,301326,1006723,9904,422088,708240,1000822,381267,27421,845391,813076,328755,191580,625185,508280,934030,849796,250638,149842,603119,113304,726843,216873,660126,907545,931108,369330,348519,439722,803591,769128,742509,610160,208763,671057,965683,349757,559985,969747,178690,716665,982186,844769,510048,920637,330311,708641,287143,755328,654909,736466,144792,878083,416936,874397,106542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]