SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 686226 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 686226 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508949,18172,223419,244100,835856,200676,767643,20814,986477,647665,228357,278287,185412,1033722,819304,122511,603621,335203,894821,375936,177578,395896,779746,1819,713492,963304,799189,811987,383876,391586,331997,978704,23445,661529,751850,327546,574929,162133,634630,87745,106075,275707,521727,869121,354426,500477,1010247,74335,1037736,544664,895586,214891,726632,217918,472856,19613,533258,601430,310633,117644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 686226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 686226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001573s ]