SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551506 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551506 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459881,481541,263874,427689,841109,668033,488155,780508,493245,1016969,252329,665528,354600,435259,1020545,770841,907846,939868,23782,897859,601772,272972,151454,340631,969158,317938,505025,157660,548013,814665,79539,395801,693885,672971,244904,288148,70096,723804,717438,554360,598357,863521,624111,454841,207205,647683,532263,56805,508446,354527,470484,690528,613033,709051,657695,678499,1047441,956888,401793,325207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]