SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003435 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003435 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984180,777868,340898,348825,500601,210305,498746,111888,873955,704091,863478,858412,330173,863714,327370,646643,840816,490439,435675,594498,241425,595232,352971,393422,566818,760814,1027087,334883,844411,212573,887914,160686,1039111,876735,48980,826743,393127,640895,699594,846702,853241,929195,238172,1001957,234598,857899,337108,160746,372360,348308,213921,348574,267703,911699,516040,751135,462847,746101,381052,326657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003435 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003435 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]