SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508801 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508801 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791479,959344,315698,783626,635554,161740,647698,335398,1023593,821080,85080,366578,464230,119829,793409,474049,351854,794716,661894,705537,383262,533151,915574,809971,436927,934232,725996,687260,361610,563971,722559,188394,49973,933946,68892,334248,208014,869370,248804,463727,352018,5243,850086,93271,926344,248304,259501,391089,913204,495503,501053,270375,839439,847311,867830,936629,1040245,534857,991793,654289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]