SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599516 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599516 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516439,1046574,796799,875498,847159,535596,176859,947583,181837,355906,915143,190127,121284,166936,668556,639365,339976,732396,980380,885802,426390,439757,868640,865045,1015619,698292,672934,852294,273835,947503,725065,254172,789581,869168,175788,523006,245628,657859,874558,707617,101173,200530,112275,51019,165016,666991,605658,296143,819073,231021,300854,289928,877858,1029441,672044,813702,293588,652782,326042,614136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]