SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343764 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343764 [ RunTime:0.001590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768868,358650,193113,678199,437527,676433,240313,732677,955125,924378,767177,199922,159791,630893,44878,646143,22540,685910,261032,881538,319290,631017,638850,779586,851630,908096,841173,44597,659431,595110,627031,864114,584775,718414,504049,693547,634120,938825,248070,536185,374638,536141,888767,870931,409809,378620,484879,710647,770554,67191,535098,1026228,720961,556888,34668,734826,463222,818946,645752,791539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343764 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343764 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]