SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002904s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671948 LIMIT 1 [ RunTime:0.001679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671948 [ RunTime:0.003966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330366,613822,833235,364179,257880,286324,418614,721321,634792,483171,180051,699854,699681,891834,775107,758619,571670,31429,912616,750385,688780,81202,422367,253451,317825,115014,746878,813270,141613,61563,769067,501829,1028586,632456,54634,466139,438159,322680,643507,230181,890893,1037508,555001,394809,549193,251847,448228,229686,250066,426062,953731,893366,443259,255768,722508,758991,562974,323308,299571,201158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]