SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584188 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584188 [ RunTime:0.001627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026960,237294,434489,255782,487177,744756,151309,757972,631395,103076,1014326,253225,730599,260915,290450,872371,642583,359311,848375,593161,417946,220492,792372,327463,483375,82482,529075,203499,509700,951884,279127,1041958,350108,51609,245389,1019867,938499,669071,874541,291917,621210,175723,500773,1014272,605991,1037263,762901,906053,608991,324269,426891,694206,987097,174198,79723,626964,549147,142368,996362,361682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001133s ]