SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301076 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301076 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012117,276277,1045097,701860,307391,1009941,994591,640321,609826,718156,461079,7482,483884,125337,885754,430270,99009,112847,1022360,857723,474903,968134,471673,489887,779444,462248,241230,226426,239172,645378,464295,287114,697522,539311,651048,711802,60090,28065,458354,654268,664821,702019,430677,772355,954476,313001,242835,171358,426555,696069,573354,961279,961727,128899,67845,516428,316019,833160,352141,245177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000906s ]