SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489418 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489418 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78112,116713,229484,242573,477420,1039810,279247,179327,76072,494031,1029629,720860,617717,397926,182892,621922,536294,397543,750579,360180,91853,803941,841463,167312,263474,1025703,375643,253575,1005556,231752,740752,541822,184545,955523,306824,766396,474440,154237,788071,687689,949817,281612,517681,697441,278743,861159,339723,300326,211697,133201,607653,438704,514153,271427,807329,954401,427548,248835,798958,63040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]