SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318220 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318220 [ RunTime:0.002690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982322,436288,527571,335618,417068,339002,265430,410782,13777,969764,400770,201647,875600,9767,353943,876338,89501,542530,610058,71375,297030,431338,72852,717775,780508,65222,951551,320061,320677,257836,464468,479084,499177,188130,486954,551840,1047744,71689,123127,828815,661184,353271,809194,623893,553628,681972,288131,759330,194825,11424,991661,301812,386216,278814,988976,407129,815331,465957,629019,710424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]