SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524323 LIMIT 1 [ RunTime:0.000555s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524323 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948658,484539,269377,170258,382136,767895,485090,175752,807522,996314,585302,728166,408321,310673,791047,1010236,101180,701468,922858,74283,30550,739851,939245,669890,738539,344975,457883,42820,5903,196520,904344,457045,84736,179551,317641,623598,480705,870109,718766,168302,1038827,231299,346308,528655,25833,735027,56993,803115,669734,1024584,472400,531098,15009,556751,465418,226016,973191,507633,263617,511751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]