SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048191 LIMIT 1 [ RunTime:0.002715s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048191 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290392,957236,336442,129170,237178,88983,244380,574266,695241,143998,413569,834869,1040563,258344,60094,800343,136360,849352,163015,967672,363242,804574,390500,329472,7300,556897,225830,68221,784286,415154,267683,531463,383564,281764,37667,751966,280177,170788,63591,492156,21430,1008571,517505,760393,691837,1039629,587551,175103,801861,118478,518436,320849,636804,210039,314974,896676,871404,93709,892540,73134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001220s ]