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` = 1029572 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029572 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600191,314220,288447,441742,181949,983558,112216,373747,521093,489059,461566,800545,337260,146922,1044947,486329,211870,956038,66532,644609,761298,255361,631649,378888,942847,626334,213865,28684,109536,440577,216969,818383,550436,314121,517279,877057,630530,964638,926840,339223,734951,887831,288399,425637,625850,126083,349958,421336,514700,8505,35652,343664,252768,760564,134740,690421,118103,568664,501046,147454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]