SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402275 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402275 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293940,1024439,824438,39721,851472,27613,164011,762645,152298,778243,353319,127346,933259,453593,89819,808639,299714,531816,557334,1039123,103359,654399,119910,868890,715708,27936,871203,254369,725005,552497,807297,765269,406079,616110,129729,196367,217329,455408,920713,312354,490487,995274,216025,105885,38864,771068,689732,313336,315038,159840,376379,618590,311961,859939,725350,220562,618562,665657,544948,173802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001082s ]