SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036597 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036597 [ RunTime:0.002658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774551,596027,311249,577657,915147,643633,521400,816837,771808,260493,750692,123960,565300,637897,38425,393118,905405,114448,590205,146048,719244,1019703,786757,866418,954436,616698,926401,589083,1034948,684250,551257,232419,627263,786235,44920,452765,632187,391136,332725,11273,424358,862233,917167,990737,510418,473583,241459,346920,33539,144926,199344,53710,42783,199217,966693,703738,623406,758976,1000339,428399) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]