SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040093 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040093 [ RunTime:0.001427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72746,543796,530485,594852,42747,363060,526058,238373,658909,1037136,829572,469195,599839,731077,59557,982812,314732,583937,212935,790806,305224,456467,969076,613499,25526,342787,129770,257473,914814,788344,149838,407688,1043260,392893,743928,855355,251992,1031131,607612,86172,752629,302738,673615,867194,740993,733124,80980,47683,593673,520224,469363,115960,659515,75503,466821,183937,640209,485668,321100,871322) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]