SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318464 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318464 [ RunTime:0.002061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349591,573241,536032,420531,210012,831382,514224,130363,1047834,412938,161445,442285,219136,835579,401487,301183,104977,722448,84218,271570,50176,6455,723537,1005727,810004,543413,844783,681624,351383,420860,1033182,393084,413052,623916,539025,388641,608622,986592,776499,713459,428926,952222,975268,101151,597378,720621,552676,833986,145550,116867,901874,768118,352323,458704,100915,708261,1037972,116523,101799,806085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]