SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405004 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405004 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521407,259375,183219,477462,905792,145381,788218,567185,225077,130317,148064,693127,5557,824506,450652,92281,1045386,139534,673458,582845,229748,99271,458202,189302,644123,161431,643248,665806,554735,785937,589957,205705,732231,371085,374844,808895,740533,288278,446949,855175,973451,471728,240401,234363,143786,885105,127503,757377,493253,79378,619770,694489,826972,318413,561903,963959,531606,195590,958346,377043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]