SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 995040 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 995040 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284345,551965,871064,857182,881257,105555,621535,811814,938505,494227,966397,558800,464572,440126,340452,698278,793296,192831,828709,896857,417136,640578,138460,305220,1025531,366788,53120,2426,891069,564451,1003924,459597,867379,282104,934688,840439,753729,846697,935684,496407,623618,246104,842505,52000,61371,25072,765175,897765,198368,67715,491859,181722,161129,97336,48823,845548,983864,734058,463237,640751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 995040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 995040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]