SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407690 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407690 [ RunTime:0.001416s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848551,567501,739677,956168,388157,42043,868021,239414,1012718,1002559,65813,654311,841905,895221,64492,755945,280979,582564,18491,366987,119582,543720,586257,399450,927743,446553,396761,24739,869505,174251,190128,340819,909100,929655,277459,564551,758383,105272,881914,775281,847557,257145,125216,1008938,43059,957098,509517,737339,474634,557798,825433,4358,915540,720475,446903,846088,94038,35736,660239,257819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]