SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539098 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539098 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965559,962700,285493,121891,170008,645569,409372,435892,5221,834625,821665,507506,820337,862171,469117,279003,944180,729550,795293,623501,567232,977095,725729,1000011,484878,880948,883146,238121,733931,861017,1031481,733543,403074,402279,736668,337846,17616,405506,1024705,910872,402357,1001239,1008604,810087,298458,520089,47735,289939,441187,752438,376348,460074,512573,583113,308702,670126,237722,16289,999446,590475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]