SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425110 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425110 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508946,209519,925244,49882,563857,970887,772104,276157,447294,181823,169471,398797,547327,1025472,674915,169210,863089,325320,1016633,485719,333656,285246,421997,401457,638804,11112,834231,451574,152531,724450,679799,687302,27890,21279,417248,147633,252123,825830,951626,870451,718419,227362,929400,678967,655114,960905,12287,135685,945024,130344,335038,604739,57962,729384,903610,755664,621620,157357,276092,915117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]