SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419842 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419842 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959073,894076,11343,937690,1019776,16111,524631,579537,242943,169284,79209,867102,829720,358114,407479,124191,632021,246629,602046,573588,1009024,909985,243067,186238,697984,47762,578585,673367,477144,781606,705838,733831,692908,301048,480777,885129,313389,153772,205703,444805,690272,347915,527399,319767,384017,51410,333286,496502,331836,688507,884124,164292,82513,819240,960242,586592,583322,617306,439608,944355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001040s ]