SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028143 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028143 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300187,20260,811062,86477,982352,36204,1036749,38346,939967,450562,485660,136949,612906,160426,226060,1000129,411718,875081,1008207,390345,620153,937953,654456,888932,606110,882813,1023843,279269,13140,587383,94381,832092,947095,120895,185727,606558,344911,800206,157314,225328,412452,940861,242148,883996,35604,94966,396428,224747,637239,144324,1020927,780475,13451,962321,938919,925032,1023497,429199,656760,370288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]