SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402341 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402341 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357461,56588,470379,524607,368221,246434,138185,889242,758647,20901,100630,402060,700066,711914,894627,95372,207195,501902,915412,910263,564282,965439,1017402,417915,505007,687526,950530,586155,678445,542023,126883,935348,390306,750065,635050,793005,344279,738806,929924,1017205,216656,681543,299090,431943,688052,1043410,260490,159703,698553,97854,296944,584866,745282,582171,68400,918416,260204,294246,860332,1009168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001634s ]