SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415542 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415542 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353251,262013,737387,1026711,910617,937325,608694,477700,819053,787865,351550,895079,1025740,229582,616475,915004,262362,391288,903822,654190,828553,280823,940277,1038816,576760,542045,719916,352976,121261,391597,713075,638040,313599,415084,712002,9180,805698,234042,842502,294916,477383,303231,410039,839771,97856,970885,1018615,109022,852541,936416,278896,157775,829378,387659,405265,787666,376737,673593,1043723,633385) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]