SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515877 LIMIT 1 [ RunTime:0.001312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515877 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805580,338211,397005,713146,461018,452217,721821,729210,1045046,212456,68439,93599,1028756,229814,122431,480100,22939,29784,90171,558423,763864,934152,403785,475925,807519,109403,915670,553683,268421,583705,608710,389021,898651,626645,401375,515538,568798,847240,790325,142559,730963,354075,318314,672348,185252,355846,188949,690758,288588,237,925907,969476,608366,696850,626029,508697,737266,1030422,872237,703829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515877 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515877 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]