SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028682 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028682 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242315,100996,720537,627746,788132,41839,177197,564811,368493,451010,122072,141367,120761,229163,793214,185900,231821,334880,885735,78839,953706,411429,938916,771829,822860,190645,965813,526581,633267,975047,479760,479058,8449,431582,1023495,471857,793140,337286,550609,123942,199157,775388,285763,358941,582394,844432,10698,472673,628740,495567,970913,951388,846880,161510,949885,719819,1045935,117463,612553,939878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]