SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508006 LIMIT 1 [ RunTime:0.000272s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508006 [ RunTime:0.001496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761189,734852,750312,954227,1007186,903633,994077,379924,737224,27585,201643,835158,61623,322166,931939,695662,172365,517844,626879,451336,555977,714467,84089,967744,274792,1048627,344790,669686,980292,915685,839827,360256,825163,14111,516498,616273,879455,905852,299496,224531,458747,76770,425157,658675,309693,584818,249187,847348,856448,575206,107113,900961,871854,611590,848234,716454,582382,232540,541305,805550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]