SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456428 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456428 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450307,753743,3039,107258,923313,1040984,280849,860249,707349,82515,818018,605279,230526,13407,579618,755761,84664,642683,382601,330373,85283,1013755,293716,951423,556745,680828,951626,155014,448034,72841,698251,176209,423858,381869,839121,150142,762336,193437,443725,175319,113420,351170,527653,143008,621680,524785,874712,534570,434652,312597,823751,7860,708037,60465,281428,1039684,907663,527863,734250,97274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]