SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001546s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384380 LIMIT 1 [ RunTime:0.000569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384380 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333820,826065,63839,32202,196677,312114,383268,240865,812193,858033,289410,380518,579033,87654,76499,249075,815233,349233,557168,278664,987980,743373,943499,197014,1011100,1012227,844924,792430,395305,527612,261426,196533,508466,160530,776913,947925,259823,923162,659352,107389,177144,294952,318748,32568,752275,428250,843238,595397,445580,53008,571898,726472,1006689,859653,792223,739112,507940,1029432,583360,809228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]