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` = 320418 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320418 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813599,955564,908419,262403,1001763,880352,836861,396169,463320,455385,930322,941297,156964,224013,833672,976256,418741,968700,797982,31057,204219,838208,42556,403765,220141,546580,273228,523909,374349,234252,16805,30873,875540,776968,445025,625438,175654,700979,167940,12633,225282,441744,51539,123227,38967,476439,271895,40065,264530,386315,251245,1008865,577976,602022,238621,280101,261287,388611,1014331,149594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006297s ]