SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454683 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454683 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488109,778230,766683,592482,904174,538570,806817,765489,708626,164759,984093,491750,907331,241899,934352,681519,993289,474535,296092,353619,986375,657988,319867,472702,826185,150615,277579,250542,240201,154625,252530,325102,532206,232891,235513,229144,110737,583616,35961,15858,991467,847600,78321,327647,109608,217905,713631,834559,881328,1005322,549443,284400,831027,669372,578099,265494,705741,888623,837366,421165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]