SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319930 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319930 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037175,24988,915747,467247,336018,507660,631547,250534,1002151,1010063,44814,186264,312940,894886,205417,828132,1011026,698507,107181,70884,81239,967540,16176,213031,881981,589491,391486,964572,999469,917919,983111,985790,793552,820700,121973,934680,121251,1045007,964832,403880,538034,13768,269321,205429,965617,388684,264384,276136,367477,568415,266464,563004,204210,623805,147781,74548,867833,559128,525021,89516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]