SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530481 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530481 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80844,548694,929733,424500,796086,430009,838747,730621,996385,559153,594577,848000,33838,929668,834697,248691,461401,420543,809872,55025,605021,848154,117028,498730,501761,558058,733899,1030456,965852,152810,466329,632930,847615,407611,12613,517017,475428,960004,152094,755705,753878,238633,883860,286119,460243,213743,779659,107411,530884,241189,122137,92875,811554,715731,810000,812178,602517,860408,222967,903531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004146s ]