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` = 551002 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551002 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402002,288908,395927,292045,800771,681296,228638,591110,797914,1011776,692472,438132,110297,291092,580784,75315,197474,97073,814246,1033473,243700,132917,73800,139882,1041482,323687,56623,595660,954777,297265,819340,743851,765858,817002,625495,268310,600108,1046535,439545,611805,673514,582890,272335,322354,247188,96153,693356,994713,486909,129286,794806,963519,256003,837155,703215,792189,655557,639641,799654,358237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]