SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544366 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544366 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819526,398440,986794,240735,852907,833156,287336,756892,264244,686184,244052,91196,434243,101336,1035821,651979,428358,543800,432920,367493,435558,155404,651835,71476,278240,406633,5407,855912,24987,207458,418422,988984,990163,865314,628996,467771,863620,105604,452152,518699,864754,162055,93826,355643,420041,722896,1039749,158299,250232,450137,623852,312328,721134,219418,788109,320577,331527,158509,951251,559707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]