SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001869s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404097 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404097 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403938,711233,1033728,201870,726133,49904,404736,1042216,354721,473386,125054,230245,243251,799144,863812,984794,572711,847416,309315,706409,421404,425655,943221,404483,212548,339801,507504,663280,695233,386212,600420,51676,69203,486957,50622,876267,157897,136484,635249,720009,777539,26584,604506,1005933,1031559,159543,942819,588521,949326,995478,414746,145896,1003270,192388,944071,575677,716140,831754,81520,969769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]