SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429377 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429377 [ RunTime:0.001997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763299,668373,261172,547402,53563,23293,500068,548483,577652,96228,369451,41868,344086,852749,398017,630681,945963,912387,712103,489678,57435,557473,1010466,601315,488089,117026,611459,159037,849704,474751,414484,260535,901232,590815,551301,430145,843740,569605,877313,576783,85633,94001,826247,361563,646391,404669,293332,255350,260971,847025,990398,881973,892045,971784,883846,914645,400608,420191,835344,889875) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429377 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429377 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]