SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001566s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644801 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644801 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511934,922399,743506,1013159,294451,273035,431389,870892,486801,136516,355253,398000,525031,467800,665115,411926,794045,274512,95025,586389,302893,312460,802720,940334,622297,213539,366172,722704,93245,839982,4978,165204,29307,356281,45055,455785,792285,235446,1021038,310091,941986,278418,655948,42172,46911,444346,35027,590959,951622,708083,689165,386142,65651,335488,256503,488081,115012,876844,935476,885458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]