SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326805 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326805 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460489,414998,221759,962246,993216,941952,635193,117838,606297,780454,457199,360166,1020698,528703,381248,859637,798901,662004,281146,648008,620675,911310,248012,676295,633047,85500,297926,489882,564604,998095,402879,348171,412211,743533,877200,956994,125871,694517,609545,490627,467169,453938,887221,137316,155972,586276,712119,615794,291659,844365,175159,141749,421110,24613,782105,908501,883540,200819,686480,822760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]