SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559816 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559816 [ RunTime:0.002975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105058,1044626,204313,844540,511444,214328,885313,665331,886793,516103,1006639,781609,305281,670321,483519,553656,68334,674634,129479,15302,127047,266856,490923,132842,561897,80384,564573,634052,792277,988952,27041,198314,860767,646562,625277,729121,176506,806473,712272,340096,1019345,373011,143456,95163,262148,694805,960615,7077,13119,560716,958223,341829,457638,753407,914935,613437,31642,248148,565724,510768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002871s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000371s ]