SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578010 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578010 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044019,537005,305897,895842,933115,856688,329380,348494,77220,560205,773701,129420,381842,692176,428131,633810,523806,1004682,1018858,541196,1044594,733537,580755,884564,75687,555948,1039445,1025074,596078,571537,864628,910540,116076,493814,316100,200796,664624,258380,692579,838058,324714,901816,204692,592424,216506,671342,418643,596402,762912,972932,712005,1012345,745033,549752,535527,472684,337710,788530,73330,374706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]