SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001910s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014809 LIMIT 1 [ RunTime:0.000510s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014809 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641110,554238,735458,781544,840648,161473,196413,501722,659311,549788,1014227,916198,778786,836285,636900,275423,867771,102568,57446,1032667,847913,718986,144710,292604,1042452,729523,313549,168727,973611,39922,446791,607937,261672,258288,831662,152449,321484,937991,222478,806929,872050,296417,767407,133322,154001,195266,678940,305932,300154,148078,415907,210222,801890,189902,151091,677179,810183,202317,979636,837202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]