SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016382 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016382 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576871,982641,689787,111196,768128,750261,866928,893330,353527,711515,583269,522000,1048267,35223,883036,158117,296090,287592,545892,399083,119303,936210,819098,901194,325390,128058,975897,376782,127120,975987,701197,367759,246614,107108,714991,775028,974656,984782,540487,833339,111651,906858,143778,139463,73053,130027,499045,669644,388193,100165,266524,269408,654257,263258,222082,667524,432195,519728,868324,269991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]