SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585203 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585203 [ RunTime:0.003126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914692,345985,978429,365903,1034429,48713,410315,883310,18596,604361,774638,423744,537116,255937,526942,443192,183966,1003894,323904,290560,887093,37291,101,174097,198560,64185,192443,89209,631319,764115,768369,621340,1006209,838444,928202,638562,609535,898121,889017,317673,503950,677611,966126,116788,748223,216789,812491,639425,945663,551217,128804,883849,887179,572968,912383,227504,173885,44818,293856,218877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]