SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162623 LIMIT 1 [ RunTime:0.001789s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162623 [ RunTime:0.003249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84091,182932,878970,230124,221639,14324,940461,422318,520591,545486,754233,310607,849292,1008842,871496,607038,688812,12845,419,254263,963847,332213,369654,931099,465987,293135,237273,143503,127216,964725,934417,213226,1035073,607013,351257,1019907,704305,319682,382081,332470,730248,358502,407867,290383,674319,689373,377505,383723,777329,794186,738229,454052,958666,149742,276944,43569,636116,395105,448919,68943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]