SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243150 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243150 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4014,626109,19699,235867,127324,1013906,862615,724414,423335,445007,545324,245688,867623,696103,185683,14293,437274,655409,191485,1004080,691694,1042236,817641,925025,48944,601558,731817,172463,635143,855592,926995,709928,314421,421617,414887,636662,519399,625701,780480,171535,21977,1024809,624380,646301,250762,409862,999567,273400,254055,492769,186519,819492,107969,124396,333554,757560,316141,1007260,937041,224346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]