SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310203 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310203 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612650,3626,787106,362195,746880,296765,853946,689686,478936,183207,189557,596711,198051,547086,590581,291951,673184,677328,13789,902218,186227,755117,335068,204664,249418,103882,785355,376764,27088,950454,404724,968877,325995,212334,305647,302974,636311,384249,330125,588024,498183,545411,126416,458609,440485,457694,908413,469586,736933,66400,979165,671483,790004,139100,820146,360956,239877,9155,840506,198482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]