SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472504 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472504 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150461,857507,195208,816130,281867,763008,778652,290194,347210,194397,513864,648936,618355,758743,177407,1012805,992555,464769,781361,348920,93734,540218,377844,886503,1028934,737211,351655,824689,281420,369432,152362,571600,737952,821475,1015939,18878,554559,451056,438520,697710,539547,797192,681443,246797,1010680,110438,29597,877906,1003909,264920,358141,505253,663797,994818,315221,440332,232031,1006456,187546,915063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]