SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517632 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517632 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532085,672891,363293,384672,578899,1046058,1001940,575202,739436,1047269,444640,727104,594867,816059,203232,340241,894511,774132,535064,238463,476465,277586,280375,169833,202792,976022,41015,640513,881022,763066,969350,628224,436518,3007,428171,452394,855190,269782,13760,885181,267607,586213,979775,95935,501019,51327,856111,101269,750252,366794,515961,386045,498823,85864,113943,923841,374758,90350,356801,736418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517632 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517632 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]