SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802510 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802510 [ RunTime:0.002264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011749,471314,230246,132773,661541,415127,243739,663645,438765,140319,739498,930644,959253,316096,398429,519906,964306,133366,906024,281502,565093,727615,243126,117810,635386,693323,214097,663110,787336,170870,901468,796159,190205,175615,250999,603019,354126,557601,689531,975084,16327,603694,191433,669731,966390,1023879,560628,573475,40600,874126,186622,376512,627764,253082,797095,825101,1007849,503896,700905,699993) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]