SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542954 LIMIT 1 [ RunTime:0.000702s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542954 [ RunTime:0.004380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217607,435680,506924,940397,1020690,68099,355641,581928,349513,278270,220849,775466,604584,576077,9896,899439,555739,452076,926690,291377,960531,790508,1022113,21327,365337,951142,709768,611288,41587,64454,521603,764825,326684,388544,827039,707502,759908,566628,238141,11594,839714,311784,275850,847429,806895,59655,475947,278318,779710,656870,881481,698050,887311,474142,880714,447290,651447,750865,320216,463190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]