SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503202 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503202 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119755,961662,297189,137639,797071,115365,295337,656575,251720,829242,144148,681087,640695,747382,857328,849210,705483,12032,106711,250747,434730,474497,270632,959494,81365,680082,510685,288973,352333,164134,254555,656791,171635,112652,76169,375265,956642,265293,939316,141502,63005,905238,111094,527770,311902,366403,955135,21283,675988,620855,977442,599538,402391,116902,801337,569550,1013109,111222,666700,887825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]