SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501190 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501190 [ RunTime:0.004982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113236,327335,523403,219511,309398,466652,678626,930977,347128,707404,182066,473125,134817,294589,36621,1025376,267808,233338,282096,516638,953569,776343,3828,906342,696934,463881,424620,931741,671264,939117,34683,704907,580672,160542,980567,971154,891145,23340,984377,682780,6879,349085,899528,783841,89063,657592,404722,304538,116674,287915,381918,972969,52777,961657,656650,68074,1024262,321118,31814,590501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]